package com.jx.gocomtask.webservice.repository;

import java.util.Date;
import java.util.List;

import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
//import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;
import org.springframework.transaction.annotation.Transactional;

import com.jx.gocomtask.webservice.entity.ExtRemindPlan;

public interface ExtRemindPlanRepository extends PagingAndSortingRepository<ExtRemindPlan,Long>{
	//@Query(value = "select e from ExtRemindPlan e where e.execTime > ?1  AND  e.execTime<=?2")
	List<ExtRemindPlan> findByExecTimeBetween(Date start,Date end);
	@Modifying
	@Transactional 
	@Query(value = "delete from ext_remind_plan where id in (?1)" , nativeQuery = true)
	void deleteRemindPlans(List<Long> plans );  
	
}
